Previous Topic

Next Topic

To format data for import

The transaction format is tab- or comma-delimited input, with various types of records allowed in a single stream. The import file must contain a single batch header record, followed by any number of cash payment records.

Note: You cannot use the Dues Importer for accrual Dues billing cycle. You must use the AR Importer for accrual dues billing. To use the AR Importer, the System field (third field) under the Cash Payment Record should be AR. Make sure to insert the Invoice Number (sixth field) under the Cash Payment Record.

The major transaction formats include the following:

All Records

 

Field Name

Data

Comments

1

Record Type

 

Identifies the type of record

2

Batch Number

10 chars, all upper case

 

Batch Header

 

Field Name

Data

Comments

1

Record Type

BH

Always "BH"

2

Batch Number

10 chars, all upper case

 

3

Batch Date

Date

Date of batch

4

Batch Description

60 chars

 

5

Control Count

Numeric

Optional

6

Control Amount

Monetary

Total of the batch of payments

7

Cash Account Code

10 chars, all upper case

Code assigned through AR/Cash> Set up tables > Cash accounts; indicates the cash account where the funds were deposited

Cash Payment Record

?

Field Name

Data

Comments

1

Record Type

PAY

Always "PAY"

2

Batch Number

10 chars, all upper case

Optional; if blank, defaults to batch header's batch number

3

System

DUES

 

4

Member ID

10 chars, customer ID

Can substitute Major Key, if prefixed with * (asterisk)

5

Date

Date

Optional; if blank, defaults to batch header date

6

Invoice

Numeric

Optional; payments can be applied to specific Product Codes by including the Product Code in this field

7

Amount

Individual payment amount

Total amount of the check or credit card payment

8

Check/CCType

Check # or credit card type

Optional

9

CCNumber

Credit card #

Optional

10

CCExp

Credit card exp

Optional

11

Name On CC

Name on credit card

Optional

12

CCAuthorize

Credit card authorization code

Optional

13

Name

60 chars for audit trail

Optional but important. Will print on the transaction report to identify the customer/subscriber.

14

Comment

255 chars

Optional but important. Will print on the transaction report and related inquiries to explain the transaction, such as "Dues Payment" or "Subscription Payment."

See Also

Using iMIS Dues Importer

To enable the iMIS Dues Importer module

Example Import File

To review history before importing transactions

To perform the import

To verify the import

To view open credits from import


ASI logo 10.5 Production Release. Updated 2/24/2006 11:15:48 AM
Copyright © by Advanced Solutions International, Inc. All rights reserved.